﻿

-- 取得所有非在场人员信息
CREATE procedure [dbo].[KqjlInfo_Get_AllFfzcRy]
as
select sfzh,xm,qybmm,kh,kbs,kqsj sj from Kqjl_Info where sfff=1 and sfzh<>'0000000000000'